home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
dir2list.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
745b
|
20 lines
/* RCSVER $Id: dir2list.sql,v 1.2 2000-01-25 16:31:50-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: dir2list.sql
* Date: 07/12/1999
* memo: Randy Wood
* Description: Create the dir2list table. This table contains the list
* of valid directions ("direction2") for a trip.
* Changes:
************************************************************************* */
CREATE TABLE dir2list
(
dirname VARCHAR2(20), /* valid direction name */
useflag NUMBER(1), /* 0=do not use in ROUTE.FBC */
/* 1=use in ROUTE.FBC */
shortname VARCHAR2(5),
CONSTRAINT pk_dir2list PRIMARY KEY (dirname)
);